/****** Object:  Stored Procedure dbo.CGO_PaymentLogGetList    Script Date: Monday, March 28, 2011 ******/
IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'dbo.CGO_PaymentLogGetList')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 ) 
  DROP PROCEDURE dbo.CGO_PaymentLogGetList
GO

/* -------------------------------------------------------------------------------------
/   PaymentLogGetList 
/  ------------------------------------------------------------------------------------- */
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE dbo.CGO_PaymentLogGetList 
  @PaymentID INT
AS 
  SELECT  PaymentLogID ,
          PaymentID ,
          AppID ,
          ProductKey ,
          ProductQuantity ,
          TransactionID ,
          TransType ,
          ApprovalCode ,
          IsTest ,
          PageNumber ,
          ReceiptNumber ,
          SalesOrderNumber
  FROM    dbo.CGO_PaymentLog
  WHERE   PaymentID = @PaymentID
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO